Columns
Grants
Dependencies
Details
Triggers
Errors
Columns
Grants
Dependencies
Details
Triggers
Errors
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS | INSERTABLE | UPDATABLE | DELETABLE |
---|---|---|---|---|---|---|---|---|
ACTIVITY_TYPE | VARCHAR2(100) | No | null | 3 | null | NO | NO | NO |
TITLE | VARCHAR2(400) | Yes | null | 4 | null | NO | NO | NO |
CREATED_ON | DATE | Yes | null | 5 | null | NO | NO | NO |
CREATED_ON_FY | NUMBER | Yes | null | 6 | null | NO | NO | NO |
DAYS_OPEN | NUMBER | Yes | null | 7 | null | NO | NO | NO |
STATUS | VARCHAR2(100) | Yes | null | 8 | null | NO | NO | NO |
ACTIVITY_DATE | DATE | Yes | null | 9 | null | NO | NO | NO |
ACTIVITY_DATE_FY | NUMBER | Yes | null | 10 | null | NO | NO | NO |
OWNING_UNIT | VARCHAR2(400) | Yes | null | 11 | null | NO | NO | NO |
LEAD | VARCHAR2(400) | Yes | null | 12 | null | NO | NO | NO |
SUPPORT_PERSONNEL | VARCHAR2(4000) | Yes | null | 13 | null | NO | NO | NO |
ASSOCIATIONS_COUNT | NUMBER | Yes | null | 14 | null | NO | NO | NO |
ATTACHMENTS_COUNT | NUMBER | Yes | null | 15 | null | NO | NO | NO |
NOTES_COUNT | NUMBER | Yes | null | 16 | null | NO | NO | NO |
BRIEFED_COUNT | NUMBER | Yes | null | 17 | null | NO | NO | NO |
OTHER_COUNT | NUMBER | Yes | null | 18 | null | NO | NO | NO |
OTHERPRE_COUNT | NUMBER | Yes | null | 19 | null | NO | NO | NO |
DISC_SUBJECT_COUNT | NUMBER | Yes | null | 20 | null | NO | NO | NO |
DISC_VICTIM_COUNT | NUMBER | Yes | null | 21 | null | NO | NO | NO |
DISC_WITNESS_COUNT | NUMBER | Yes | null | 22 | null | NO | NO | NO |
MAG_COUNT | NUMBER | Yes | null | 23 | null | NO | NO | NO |
CUST_AGENCY_COUNT | NUMBER | Yes | null | 24 | null | NO | NO | NO |
POC_COUNT | NUMBER | Yes | null | 25 | null | NO | NO | NO |
SUBJECT | NUMBER | Yes | null | 26 | null | NO | NO | NO |
CLOSED_ON | DATE | Yes | null | 27 | null | NO | NO | NO |
CLOSED_ON_FY | NUMBER | Yes | null | 28 | null | NO | NO | NO |
NEXT_DUE_DATE | DATE | Yes | null | 29 | null | NO | NO | NO |
FINAL_DUE_DATE | DATE | Yes | null | 30 | null | NO | NO | NO |
FINAL_DUE_DATE_FY | NUMBER | Yes | null | 31 | null | NO | NO | NO |
FINAL_DUE_DATE_MET | VARCHAR2(3) | Yes | null | 32 | null | NO | NO | NO |
OBJ | VARCHAR2(20) | No | null | 1 | null | NO | NO | NO |
ID | VARCHAR2(100) | Yes | null | 2 | null | NO | NO | NO |
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|
References
NAME | VALUE |
---|---|
CREATED | 12-APR-23 |
LAST_DDL_TIME | 05-FEB-25 |
OWNER | QART |
VIEW_NAME | V_SIII_INV_ACTS |
TEXT_LENGTH | 8180 |
TEXT | SELECT DISTINCT O.SID OBJ, O.ID ID, OT.DISPLAY ACTIVITY_TYPE, O.TAGLINE TITLE, O.CREATED_ON CREATED_ON, O.CREATED_ON_FY CREATED_ON_FY, CASE WHEN S1.DISPLAY = 'Closed' THEN ( TRUNC(S.STARTED_ON) - TRUNC(O.CREATED_ON) ) ELSE ( TRUNC(SYSDATE) - TRUNC(O.CREATED_ON) ) END DAYS_OPEN, S1.DISPLAY STATUS, COALESCE(BRIEFING.ACTIVITY_DATE, COORD.ACTIVITY_DATE, DOC_REV.ACTIVITY_DATE, EXCEPTN.ACTIVITY_DATE) ACTIVITY_DATE, COALESCE(BRIEFING.ACTIVITY_DATE_FY, COORD.ACTIVITY_DATE_FY, DOC_REV.ACTIVITY_DATE_FY, EXCEPTN.ACTIVITY_DATE_FY) ACTIVITY_DATE_FY , OU.SH_DISPLAY OWNING_UNIT, L.SH_DISPLAY LEAD, SO.SH_DISPLAY SUPPORT_PERSONNEL, ( SELECT COUNT(1) FROM MV_ACM_ASSOCIATION WHERE FROM_OBJ = O.SID OR TO_OBJ = O.SID ) ASSOCIATIONS_COUNT, ( SELECT COUNT(1) FROM MV_ACM_ATTACHMENT WHERE OBJ = O.SID ) ATTACHMENTS_COUNT, ( SELECT COUNT(1) FROM MV_ACM_NOTE WHERE OBJ = O.SID ) NOTES_COUNT, ( SELECT COUNT(1) FROM MV_PARTIC_INVOLVEMENT WHERE OBJ = O.SID AND INVOLVEMENT_ROLE IN ( SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'BRIEFED' ) ) BRIEFED_COUNT, ( SELECT COUNT(1) FROM MV_PARTIC_INVOLVEMENT WHERE OBJ = O.SID AND INVOLVEMENT_ROLE IN ( SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'OTHER' ) ) OTHER_COUNT, ( SELECT COUNT(1) FROM MV_PARTIC_INVOLVEMENT WHERE OBJ = O.SID AND INVOLVEMENT_ROLE IN ( SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'OTHERPRE' ) ) OTHERPRE_COUNT, ( SELECT COUNT(1) FROM MV_PARTIC_INVOLVEMENT WHERE OBJ = O.SID AND INVOLVEMENT_ROLE IN ( SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'DISC_SUBJECT' ) ) DISC_SUBJECT_COUNT, ( SELECT COUNT(1) FROM MV_PARTIC_INVOLVEMENT WHERE OBJ = O.SID AND INVOLVEMENT_ROLE IN ( SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'DISC_VICTIM' ) ) DISC_VICTIM_COUNT, ( SELECT COUNT(1) FROM MV_PARTIC_INVOLVEMENT WHERE OBJ = O.SID AND INVOLVEMENT_ROLE IN ( SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'DISC_WITNESS' ) ) DISC_WITNESS_COUNT, ( SELECT COUNT(1) FROM MV_PARTIC_INVOLVEMENT WHERE OBJ = O.SID AND INVOLVEMENT_ROLE IN ( SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'MAG' ) ) MAG_COUNT, ( SELECT COUNT(1) FROM MV_PARTIC_INVOLVEMENT WHERE OBJ = O.SID AND INVOLVEMENT_ROLE IN ( SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'CUST_AGENCY' ) ) CUST_AGENCY_COUNT, ( SELECT COUNT(1) FROM MV_PARTIC_INVOLVEMENT WHERE OBJ = O.SID AND INVOLVEMENT_ROLE IN ( SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'POC' ) ) POC_COUNT, ( SELECT COUNT(1) FROM MV_PARTIC_INVOLVEMENT WHERE OBJ = O.SID AND INVOLVEMENT_ROLE IN ( SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'SUBJECT' ) ) SUBJECT, CASE S.STATUS WHEN ( SELECT SID FROM MV_ACM_STATUS WHERE CODE = 'CLOSED' ) THEN S.STARTED_ON ELSE NULL END CLOSED_ON, CASE S.STATUS WHEN ( SELECT SID FROM MV_ACM_STATUS WHERE CODE = 'CLOSED' ) THEN S.STARTED_ON_FY ELSE NULL END CLOSED_ON_FY, O.NEXT_DUE_DATE, O.FINAL_DUE_DATE, O.FINAL_DUE_DATE_FY, CASE WHEN S1.DISPLAY = 'Closed' AND TRUNC(S.STARTED_ON) <= TRUNC(O.FINAL_DUE_DATE) THEN 'Yes' ELSE 'No' END FINAL_DUE_DATE_MET FROM MV_ACM_OBJ O INNER JOIN MV_ACM_OBJ_TYPE OT ON O.OBJ_TYPE = OT.SID AND OT.OBJ_TYPE_CODE IN ( 'ACT.BRIEFING.ISD', 'ACT.DOC_REVIEW.ISD', 'ACT.EXCEPTION.ISD', 'ACT.COORD.ISD' ) LEFT JOIN MV_A_BRIEFING BRIEFING ON O.SID = BRIEFING.OBJ LEFT JOIN MV_A_COORDINATION COORD ON O.SID = COORD.OBJ LEFT JOIN MV_A_DOCUMENT_REVIEW DOC_REV ON O.SID = DOC_REV.OBJ LEFT JOIN MV_A_EXCEPTION EXCEPTN ON O.SID = EXCEPTN.OBJ LEFT JOIN MV_ACM_STATUS_HISTORY S ON O.SID = S.OBJ AND S.COMPLETED_ON IS NULL LEFT JOIN MV_ACM_STATUS S1 ON S1.SID = S.STATUS LEFT JOIN MV_ACM_PLACE V ON O.SID = V.OBJ LEFT JOIN V_CURR_OBJ_OWNING_UNIT OU ON O.SID = OU.OBJ LEFT JOIN V_CURR_OBJ_LEAD_PERS L ON O.SID = L.OBJ LEFT JOIN ( SELECT OBJ, LISTAGG(SH_DISPLAY, ';' || CHR(13)) WITHIN GROUP( ORDER BY SH_DISPLAY) OVER(PARTITION BY OBJ) SH_DISPLAY FROM V_CURR_OBJ_SUPPORT_OFFICER ) SO ON O.SID = SO.OBJ |
TEXT_VC | SELECT DISTINCT O.SID OBJ, O.ID ID, OT.DISPLAY ACTIVITY_TYPE, O.TAGLINE TITLE, O.CREATED_ON CREATED_ON, O.CREATED_ON_FY CREATED_ON_FY, CASE WHEN S1.DISPLAY = 'Closed' THEN ( TRUNC(S.STARTED_ON) - TRUNC(O.CREATED_ON) ) ELSE ( TRUNC(SYSDATE) - TRUNC(O.CREATED_ON) ) END DAYS_OPEN, S1.DISPLAY STATUS, COALESCE(BRIEFING.ACTIVITY_DATE, COORD.ACTIVITY_DATE, DOC_REV.ACTIVITY_DATE, EXCEPTN.ACTIVITY_DATE) ACTIVITY_DATE, COALESCE(BRIEFING.ACTIVITY_DATE_FY, COORD.ACTIVITY_DATE_FY, DOC_REV.ACTIVITY_DATE_FY, EXCEPTN.ACTIVITY_DATE_FY) ACTIVITY_DATE_FY , OU.SH_DISPLAY OWNING_UNIT, L.SH_DISPLAY LEAD, SO.SH_DISPLAY SUPPORT_PERSONNEL, ( SELECT COUNT(1) FROM MV_ACM_ASSOCIATION WHERE FROM_OBJ = O.SID OR TO_OBJ = O.SID ) ASSOCIATIONS_COUNT, ( SELECT COUNT(1) FROM MV_ACM_ATTACHMENT WHERE OBJ = O.SID ) ATTACHMENTS_COUNT, ( SELECT COUNT(1) FROM MV_ACM_NOTE WHERE OBJ = O.SID ) NOTES_COUNT, ( SELECT COUNT(1) FROM MV_PARTIC_INVOLVEMENT WHERE OBJ = O.SID AND INVOLVEMENT_ROLE IN ( SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'BRIEFED' ) ) BRIEFED_COUNT, ( SELECT COUNT(1) FROM MV_PARTIC_INVOLVEMENT WHERE OBJ = O.SID AND INVOLVEMENT_ROLE IN ( SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'OTHER' ) ) OTHER_COUNT, ( SELECT COUNT(1) FROM MV_PARTIC_INVOLVEMENT WHERE OBJ = O.SID AND INVOLVEMENT_ROLE IN ( SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'OTHERPRE' ) ) OTHERPRE_COUNT, ( SELECT COUNT(1) FROM MV_PARTIC_INVOLVEMENT WHERE OBJ = O.SID AND INVOLVEMENT_ROLE IN ( SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'DISC_SUBJECT' ) ) DISC_SUBJECT_COUNT, ( SELECT COUNT(1) FROM MV_PARTIC_INVOLVEMENT WHERE OBJ = O.SID AND INVOLVEMENT_ROLE IN ( SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'DISC_VICTIM' ) ) DISC_VICTIM_COUNT, ( SELECT COUNT(1) FROM MV_PARTIC_INVOLVEMENT WHERE OBJ = O.SID AND INVOLVEMENT_ROLE IN ( SELECT SID |
TYPE_TEXT_LENGTH | null |
TYPE_TEXT | null |
OID_TEXT_LENGTH | null |
OID_TEXT | null |
VIEW_TYPE_OWNER | null |
VIEW_TYPE | null |
SUPERVIEW_NAME | null |
EDITIONING_VIEW | N |
READ_ONLY | N |
CONTAINER_DATA | N |
BEQUEATH | DEFINER |
ORIGIN_CON_ID | 16 |
DEFAULT_COLLATION | USING_NLS_COMP |
CONTAINERS_DEFAULT | NO |
CONTAINER_MAP | NO |
EXTENDED_DATA_LINK | NO |
EXTENDED_DATA_LINK_MAP | NO |
HAS_SENSITIVE_COLUMN | NO |
ADMIT_NULL | NO |
PDB_LOCAL_ONLY | NO |
DUPLICATED | N |
SHARDED | N |
OWNER | TRIGGER_NAME | TRIGGER_TYPE | TRIGGERING_EVENT | STATUS | OBJECT_ID |
---|
ATTRIBUTE | Line:Position | TEXT |
---|